Welcome to the Microsoft BI Tutorials. The objective of these tutorials is to gain understanding of Microsoft BI Tool. We will cover topics such as event handlers, logging, scd and check points.
In addition to these free Microsoft BI Tutorials, we will also cover common Interview Questions, Issues of Microsoft BI,
About Microsoft BI (Business Intelligence)
Microsoft Business Intelligence is a process or set of activities such as extracting the business data from various operational sources, transform, and load the data into consolidated database or data ware house systems.
That consolidated data should be reported and analyzed to make better decisions in order to improve the organization.
Note:
Simply Business intelligence is a broad category of applications and technologies for gathering, storing, analyzing and providing access to data to help enterprise users make better business decisions.
BI Applications: BI applications include the activities of decision support systems, query and reporting, online analytical processing, statistical analysis, forecasting and data mining.
Why learn MSBI?
- MSBI allows storing and retrieving data for smart processing and rapid decisions in business.
- This Business Intelligence suite from Microsoft consists of resourceful tools providing the best solutions for Business Intelligence.
- The demand for SSAS, SSIS, and SSRS Professionals is rising lately, and many reputed companies are looking for skilled business intelligent candidates.
- The online training on BI is a complete package to learn all the mentioned SQL Server Services and tools.
Interested in mastering MSBI Training? Enroll now for FREE demo
on MSBI Training.
What is meant by MSBI technology?
MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools that help in providing the best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with an SQL server. It empowers users to gain access to accurate and up-to-date information for better decision-making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.
MSBI is divided into 3 categories:-
- SSIS – SQL Server Integration Services – Integration tool.
- SSAS – SQL Server Analytical Services -Analysis tool.
- SSRS – SQL Server Reporting Services – Reporting tool.
MSBI Tools
Microsoft provides some tools to transform your business data into information. We can use these tools with the interface of Visual Studio.
With the release of SQL Server 2012, Business Intelligence Development Studio (BIDS) was renamed to SQL Server Data Tools (SSDT).
SQL Server Data Tools(SSDT)
The following provides a brief description of BI Tools:
MSBI is composed of tools that help in providing the best solutions for Business Intelligence and Data Mining Queries. These are the three tools we are using for ETL, Analysis and
reporting in MSBI.
SQL Server Integration Service (SSIS)
SSIS is the ETL tool from Microsoft. Integration Services is a platform for building high-performance data integration and workflow solutions, including extraction, transformation and loading (ETL) operations for data warehousing. We can process the data from various locations and various formats (source locations) and save the data into a centralized repository as a
Data Warehouse/Data Mart (destination). It includes graphical tools and wizards for building and debugging packages. This tool is used for the integration like duping the data from one database to another like from Oracle to SQL Server or from Excel to
Sql Server etc. This tool is also used for bulk transactions in the database like inserting lac's of records at once.
SQL Server Analysis Service (SSAS)
This is the process of converting two-dimensional (rows and columns/OLTP) data into a multi-dimensional data model (OLTP). This will help you to analyze the large volume of data. This tool is used to analyse the performance of the SQL server in terms of load balancing, heavy data, transaction,s etc. So it is more or less related to the administration of the SQL Server using this tool. This is a very powerful tool and through this, we can analyse the data inserted into the database like how many transactions happen in a second etc.
Some of the advantages are:
- Multi-dimensional analysis
- Key Performance Indicator (KPI)
- Score card
- Slice, dice, drill-down functionalities
- Good performance
- Security and so on.
SQL Server Reporting Service (SSRS)
Microsoft SQL Server Reporting Services (SSRS) is an enterprise reporting platform supporting traditional and interactive reports delivered over the web or through custom applications. It supports various data sources like two-dimensional and multi-dimensional. This tool is related to the generation of reports. This is a very efficient tool as it is platform-independent. We can generate the report using this tool and can use it in any type of application. Nowadays this is very popular in the market.
The following are some features of SSRS:
- Retrieve data from a different source
- Web-based access to reports
- Support for Ad-hoc reporting
- Report builder helps to customize the reports for end-user.
- Easy subscriptions options
- Export functionality with lots of formats.
- Display reports in various ways like tabular, Chart, Gauge, and so on.
